<!doctype HTML public "-//W3C//DTD HTML 4.0 Frameset//EN">
<html>
<head>
<meta http-equiv="content-type" content="text/html; charset=utf-8">
<meta name="generator" content="Adobe RoboHelp - www.adobe.com">
<title>Answering a prompt by defining a filter based on an attribute</title>
<link rel="stylesheet" href="userhelp_ns.css"><script type="text/javascript" language="JavaScript" title="WebHelpSplitCss">
<!--
if (navigator.appName !="Netscape")
{   document.write("<link rel='stylesheet' href='userhelp.css'>");}
//-->
</script>
<style type="text/css">
<!--
ul.whs1 { list-style:disc; }
ol.whs2 { list-style:decimal; }
ul.whs3 { list-style:square; }
p.whs4 { margin-left:0px; }
img_whs5 { border:none; width:13px; height:16px; float:none; border-style:none; }
-->
</style><script type="text/javascript" language="JavaScript">
<!--
if ((navigator.appName == "Netscape") && (parseInt(navigator.appVersion) == 4))
{
  var strNSS = "<style type='text/css'>";
  strNSS += "p.whs4 {margin-left:1pt; }";
  strNSS +="</style>";
  document.write(strNSS);
}
//-->
</script>
<script type="text/javascript" language="JavaScript" title="WebHelpInlineScript">
<!--
function reDo() {
  if (innerWidth != origWidth || innerHeight != origHeight)
     location.reload();
}
if ((parseInt(navigator.appVersion) == 4) && (navigator.appName == "Netscape")) {
	origWidth = innerWidth;
	origHeight = innerHeight;
	onresize = reDo;
}
onerror = null; 
//-->
</script>
<style type="text/css">
<!--
div.WebHelpPopupMenu { position:absolute; left:0px; top:0px; z-index:4; visibility:hidden; }
-->
</style><script type="text/javascript" language="javascript1.2" src="whmsg.js"></script>
<script type="text/javascript" language="javascript" src="whver.js"></script>
<script type="text/javascript" language="javascript1.2" src="whproxy.js"></script>
<script type="text/javascript" language="javascript1.2" src="whutils.js"></script>
<script type="text/javascript" language="javascript1.2" src="whlang.js"></script>
<script type="text/javascript" language="javascript1.2" src="whtopic.js"></script>
</head>
<body><script type="text/javascript" language="javascript1.2">
<!--
if (window.gbWhTopic)
{
	if (window.addTocInfo)
	{
	addTocInfo("Running and viewing reports and documents\nRunning and viewing a report\nAnswering questions for a prompted report\nAnswering a prompt by defining a filter based on an attribute");
addButton("show",BTN_TEXT,"Show","","","","",0,0,"","","");

	}
	if (window.writeBtnStyle)
		writeBtnStyle();

	if (window.writeIntopicBar)
		writeIntopicBar(1);

	if(1)
	{
	
	}

	if (window.setRelStartPage)
	{
	setRelStartPage("MicroStrategy_Web_Help.htm");

		autoSync(1);
		sendSyncInfo();
		sendAveInfoOut();
	}
}
else
	if (window.gbIE4)
		document.location.reload();

//-->
</script>
<h1>Answering a prompt by defining a filter based on an attribute</h1>
<p>Some prompted reports require you to define the report's filtering conditions 
 based on an attribute.</p>
<p>These types of prompts include the following:</p>
<ul type="disc" class="whs1">
	
<li class=p><p>A prompt where you select a hierarchy from a drop-down 
 list, and then select an attribute to create a filter for the attribute. 
 (This is a hierarchy prompt.)</p></li>
	
<li class=p><p>A prompt where you create a filter based on an attribute. 
 (This is an attribute prompt.)</p></li>
</ul>
<p>If you attempt to run a report that contains a required prompt without 
 answering the required prompt, the report will not run, and a message 
 stating this requirement is displayed.</p>
<h2>To answer a prompt by defining a filter based on an attribute</h2>
<ol type="1" class="whs2">
	
<li class=p><p>Click the name of a prompted report to run it. A prompted 
 report will present a prompt question to be answered before the report 
 data is displayed.</p></li>
	
<li class=p><p>If the prompt already has an answer (a filtering condition) 
 in the right pane, you can do one of the following:</p></li>
	<ul>
<li style="list-style: disc;" type=disc class=p><p>Change the existing 
 answer (filtering condition) using the information in the next step.</p></li>
		
<li style="list-style: disc;" type=disc class=p><p>Add other answers 
 (filtering conditions) to it using the information in the next step.</p></li>
		
<li style="list-style: disc;" type=disc class=p><p>Click <span 
 style="font-weight: bold;"><B>Next</B></span> and proceed to answer other prompts, 
 or if this was the only prompt, you can run the report or document.</p></li>
	</ul>
	
<li class=p><p>If the prompt does not have an answer in the right pane, 
 or you want to add to or change answers (filtering conditions), create 
 your filter by performing all of the following:</p></li>
</ol>
<ol><ul type="disc" class="whs1">
		
<li class=p><p>Click in the right pane to start creating your filter.</p></li>
		
<li class=p><p>Next to <span style="font-weight: bold;"><B>Attribute</B></span>, 
 browse to select the attribute that has the elements for which you want 
 to see data. Depending on the type of prompt you are answering, this field 
 may not be available for selection.</p></li>
		
<li class=p><p>From the <span style="font-weight: bold;"><B>Qualify 
 On</B></span> drop-down list, select whether you want to filter data based 
 on:</p></li>
		<ul type="square" class="whs3">
			
<li class=p><p><span style="font-weight: bold;"><B>Elements</B></span>: 
 These are the individual elements of the attribute listed at the top of 
 the Attribute Qualification pane. For example, if the attribute is Year, 
 elements might include 2005, 2006, and so on. If you want to filter data 
 based on specific attribute elements, select <span style="font-weight: bold;"><B>Elements</B></span>.</p></li>
			
<li class=p><p><span style="font-weight: bold;"><B>ID</B></span> form: 
 Each attribute element has a specific ID assigned to it. If you know the 
 ID or range of IDs you want to filter data for, select <span style="font-weight: bold;"><B>ID</B></span>.</p></li>
			
<li class=p><p><span style="font-weight: bold;"><B>Description</B></span> 
 form: Most attribute elements have a description provided for them. If 
 you want to filter data based on descriptions, select <span style="font-weight: bold;"><B>Description</B></span>.</p></li>
			
<li class=p><p>Other forms: There may be other forms from &nbsp;which 
 to choose, depending on the attribute and on how your project was designed.</p></li>
		</ul>
		
<li class=p><p>From the <span style="font-weight: bold;"><B>Operator</B></span> 
 list, select the operator that will help you define your filter. For example, 
 you might choose the Greater Than operator to filter out data that is 
 below a certain number. For more details on operators, see <span style="font-style: italic;"><I>Joining 
 filter qualifications with operators</I></span> in the <span style="font-style: italic;"><I>MicroStrategy</I></span> 
 <span style="font-style: italic;"><I>Basic Reporting Guide</I></span>.</p></li>
		
<li class=p><p>Depending on what you chose to qualify on above, 
 perform one of the following:</p></li>
		<ul type="square" class="whs3">
			
<li class=p><p><span style="font-weight: bold;"><B>Element List</B></span>: 
 Click <span style="font-weight: bold;"><B>Add</B></span> and select the attribute 
 elements for which you want to filter data.</p></li>
			
<li class=p><p><span style="font-weight: bold;"><B>ID Value</B></span>: 
 Type the ID number(s) for which you want to filter data.</p></li>
			
<li class=p><p><span style="font-weight: bold;"><B>Date Value</B></span>: 
 Click the <span style="font-weight: bold;"><B>Calendar</B></span> icon to select 
 the exact date or range of dates for which you want to filter data.</p></li>
		</ul>
	</ul>
</ol>
<ol start="4" type="1" class="whs2">
	
<li class=p><p>When you are finished defining your filter, if there 
 is another prompt on the report or document scroll down or click <span 
 style="font-weight: bold;"><B>Next</B></span> to answer the next prompt. Use 
 the links below for steps to answer other types of prompts. </p></li>
	
<li class=p><p>When you are finished answering prompts, review the 
 summary of your answers and click <span style="font-weight: bold;"><B>Run 
 Report</B></span> or <span style="font-weight: bold;"><B>Run Document</B></span>. 
 The report or document is executed and your results are displayed.</p></li>
	
<li class=p><p>If you want to save and reuse your answers, see 
<a href="Save_prompt_answers.htm">Saving 
 and reusing prompt answers</a>.</p></li>
	
<li class=p><p>If you want to see how your prompt answers were used 
 to create the report’s filter, from the <span style="font-weight: bold;"><B>File</B></span> 
 menu select <span style="font-weight: bold;"><B>Report Details </B></span>or 
 <span style="font-weight: bold;"><B>Document Details</B></span>. Your prompt 
 answers appear in the form of report filtering conditions. You can also 
 see whether a cache was used to supply the results. If a cache was not 
 used, the results were taken from the latest data in your data source.</p></li>
</ol>
<p class="whs4">To see data filtered in a different way, click 
 the <span style="font-weight: bold;"><B>Reprompt</B></span> icon <img src="images/reprompt.gif" x-maintain-ratio="TRUE" width="13px" height="16px" border="0" class="img_whs5"> 
 on the toolbar that displays from the <span style="font-weight: bold;"><B>Home 
 </B></span><span>menu</span> and answer the prompt again to create a different 
 filter for the report results.</p>
<h2>Renaming a prompted report</h2>
<p>When you run a prompted report or document, you are presented with a 
 prompt before you see any report results. At the bottom of the prompt 
 selection page, you can rename the prompted report. This allows you to 
 choose a meaningful name that makes it easier to later find the report 
 or document in your History List or your My Reports folder.</p>
<p>For example, for a prompted sales report, if you answer a prompt question 
 by specifying the month of October, you can rename the report &quot;October 
 Sales&quot;. Note that this name change is reflected only in your personal 
 version of the report (in your History List or My Reports folder). It 
 does not change the actual name of the report object in MicroStrategy.</p>
<h3>Related topics</h3>
<ul type="disc" class="whs1">
	
<li class=p><p>
<a HREF="Answer_prompt_using_list.htm">Answering a prompt 
 by selecting answers from a list</a></p></li>
	
<li class=p><p>
<a HREF="Answer_prompt_with_value.htm">Answering a prompt 
 by typing a specific value</a></p></li>
	
<li class=p><p>
<a href="Answer_prompt_filter_on_metric.htm">Answering 
 a prompt by defining a filter based on a metric calculation</a></p></li>
</ul>
<script type="text/javascript" language="javascript1.2">
<!--
highlightSearch();
if (window.writeIntopicBar)
	writeIntopicBar(0);
if(0)
{

}
//-->
</script>
</body>
</html>
